package com.mnc.util;

public class Helper {
	//用户类型(和数据库typeId对应)
	public static final int ADMIN_UTYPE=1;
	public static final int CHECKER_UTYPE=2;
	public static final int PUBLIC_UTYPE=3;
	//管理员登陆标识
	public static final String MANAGE_LOGIN="ADMINLOGIN";
	public static final String PUBLIC_LOGIN="USERLOGIN";
	//分页每页记录数
	public static final int PAGE_SIZE=20;
		//后台用户登陆查询条件
	public static final String WHERE_USER_LOGIN="o.userLoginName=? and o.myType.typeId in("+ADMIN_UTYPE+","+CHECKER_UTYPE+")";
	//后台用户查询
	public static final String WHERE_SHOW_MANAGE_USER="o.myType.typeId in("+ADMIN_UTYPE+","+CHECKER_UTYPE+")";
	//分类的文章数量
	public static final String WHERE_ARTICLE_TYPE="o.articleType.typeId=?";
	//显示举报信
	public static final String WHERE_GET_NEW_ACCUSE="o.noticeRead=? and o.reciver.myType="+CHECKER_UTYPE+" order by o.noticeDate desc";
	//显示空间留言
	public static final String WHERE_GET_PNOTE="o.noteView=? order by o.noteDate desc";
	//显示文章评论
	public static final String WHERE_GET_ACOMMENT="o.commentView=? order by o.commentDate desc";
	//显示用户空间
	public static final String WHERE_GET_UPAGE="o.pageView=? order by o.buildDate desc";
	//显示用户文章
	public static final String WHERE_GET_UARTICLE="o.articleView=? order by o.articleDate desc";
	//显示用户团发言
	public static final String WHERE_GET_UTALK="o.talkView=? order by o.talkDate desc";
}
